
#%%
import pandas as pd 

base_result = pd.read_csv('changed_t2_0_predict_table.csv',header=None)
base_result.columns = ['report_date','total_purchase_amt','total_redeem_amt']

# %%
d_amt = 10**7
changed_result = base_result.copy()
# changed_result['total_purchase_amt'] += 5*d_amt
# changed_result['total_redeem_amt'] += -1.2*d_amt
changed_result.loc[1,'total_purchase_amt'] -= 8.75*d_amt
changed_result.loc[1,'total_redeem_amt'] += 0.75*d_amt

changed_result = changed_result.astype('int')

#%%
changed_result.to_csv(
    'changed_t2_1_predict_table.csv',
    columns = ['report_date','total_purchase_amt',	'total_redeem_amt'],
    header = False,index = False)
# %%
